﻿CREATE TABLE [dbo].[Location] (
    [LocationId]   INT           NOT NULL,
    [LocationName] NVARCHAR (50) NULL,
    [CountryId]    INT           NOT NULL,
    CONSTRAINT [PK_Location] PRIMARY KEY CLUSTERED ([LocationId] ASC),
    CONSTRAINT [FK_Location_Country] FOREIGN KEY ([CountryId]) REFERENCES [dbo].[Country] ([CountryId])
);

